Import Required Library

In [1]:
import numpy as np
import pandas as pd
import os
import matplotlib.pyplot as plt
import plotly.express as px
In [2]:
import plotly
plotly.offline.init_notebook_mode()
In [3]:
# Avoids scroll-in-the-scroll in the entire Notebook
from IPython.display import Javascript
def resize_colab_cell():
  display(Javascript('google.colab.output.setIframeHeight(0, true, {maxHeight: 50000})'))
get_ipython().events.register('pre_run_cell', resize_colab_cell)

Mounting Google Drive

In [4]:
from google.colab import drive
drive.mount('/content/drive')
Mounted at /content/drive
In [ ]:
%%shell
jupyter nbconvert --to html /content/.ipynb

Import data

In [5]:
data = pd.read_csv('/content/drive/MyDrive/menu.csv')
In [6]:
data
Out[6]:
Category Item Serving Size Calories Calories from Fat Total Fat Total Fat (% Daily Value) Saturated Fat Saturated Fat (% Daily Value) Trans Fat Cholesterol Cholesterol (% Daily Value) Sodium Sodium (% Daily Value) Carbohydrates Carbohydrates (% Daily Value) Dietary Fiber Dietary Fiber (% Daily Value) Sugars Protein Vitamin A (% Daily Value) Vitamin C (% Daily Value) Calcium (% Daily Value) Iron (% Daily Value)
0 Breakfast Egg McMuffin 4.8 oz (136 g) 300 120 13.0 20 5.0 25 0.0 260 87 750 31 31 10 4 17 3 17 10 0 25 15
1 Breakfast Egg White Delight 4.8 oz (135 g) 250 70 8.0 12 3.0 15 0.0 25 8 770 32 30 10 4 17 3 18 6 0 25 8
2 Breakfast Sausage McMuffin 3.9 oz (111 g) 370 200 23.0 35 8.0 42 0.0 45 15 780 33 29 10 4 17 2 14 8 0 25 10
3 Breakfast Sausage McMuffin with Egg 5.7 oz (161 g) 450 250 28.0 43 10.0 52 0.0 285 95 860 36 30 10 4 17 2 21 15 0 30 15
4 Breakfast Sausage McMuffin with Egg Whites 5.7 oz (161 g) 400 210 23.0 35 8.0 42 0.0 50 16 880 37 30 10 4 17 2 21 6 0 25 10
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
255 Smoothies & Shakes McFlurry with Oreo Cookies (Small) 10.1 oz (285 g) 510 150 17.0 26 9.0 44 0.5 45 14 280 12 80 27 1 4 64 12 15 0 40 8
256 Smoothies & Shakes McFlurry with Oreo Cookies (Medium) 13.4 oz (381 g) 690 200 23.0 35 12.0 58 1.0 55 19 380 16 106 35 1 5 85 15 20 0 50 10
257 Smoothies & Shakes McFlurry with Oreo Cookies (Snack) 6.7 oz (190 g) 340 100 11.0 17 6.0 29 0.0 30 9 190 8 53 18 1 2 43 8 10 0 25 6
258 Smoothies & Shakes McFlurry with Reese's Peanut Butter Cups (Medium) 14.2 oz (403 g) 810 290 32.0 50 15.0 76 1.0 60 20 400 17 114 38 2 9 103 21 20 0 60 6
259 Smoothies & Shakes McFlurry with Reese's Peanut Butter Cups (Snack) 7.1 oz (202 g) 410 150 16.0 25 8.0 38 0.0 30 10 200 8 57 19 1 5 51 10 10 0 30 4

260 rows × 24 columns

Data Visualization

Calories and Total Fat

In [7]:
lists = data['Category'].unique().tolist()
In [8]:
for list in lists:
    #items ascending=False
    items=data.query('Category == list').sort_values(by="Calories", ascending=False)
    items_custom=items.iloc[:,[1,3,5]]
    
    #items ascending=True
    items_t=data.query('Category == list').sort_values(by="Calories", ascending=True)
    items_custom_t=items_t.iloc[:,[1,3,5]]
    
    #Print Categories
    print(lists.index(list)+1,".",list)
    
    #Plotly Express
    p_express = px.scatter(items_custom, x="Total Fat",y='Calories', color="Item",size='Calories', 
                           template="plotly_dark",hover_name="Item")
    p_express.show()
    
    #Display Tables ranked by calories
    table=items_custom.iloc[:,[0,1,2]].sort_values(by="Calories", ascending=False).style.hide_index()
    #table=table.style.hide_index()
    display(table)
    
    #Matplotlib pyplot
    fig,ax=plt.subplots()
    x=items_custom_t.iloc[:,0]
    y=items_custom_t.iloc[:,1]
    ax.barh(x, y, tick_label=x, align='edge')
    plt.show()
1 . Breakfast
Item Calories Total Fat
Big Breakfast with Hotcakes (Large Biscuit) 1150 60.000000
Big Breakfast with Hotcakes (Regular Biscuit) 1090 56.000000
Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) 1050 50.000000
Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) 990 46.000000
Big Breakfast (Large Biscuit) 800 52.000000
Big Breakfast (Regular Biscuit) 740 48.000000
Big Breakfast with Egg Whites (Large Biscuit) 690 41.000000
Steak, Egg & Cheese Bagel 670 35.000000
Big Breakfast with Egg Whites (Regular Biscuit) 640 37.000000
Bacon, Egg & Cheese Bagel 620 31.000000
Sausage Biscuit with Egg (Large Biscuit) 570 37.000000
Bacon, Egg & Cheese Bagel with Egg Whites 570 25.000000
Sausage, Egg & Cheese McGriddles 550 31.000000
Steak & Egg Biscuit (Regular Biscuit) 540 32.000000
Sausage Biscuit with Egg Whites (Large Biscuit) 520 32.000000
Hotcakes and Sausage 520 24.000000
Bacon, Egg & Cheese Biscuit (Large Biscuit) 520 30.000000
Sausage Biscuit with Egg (Regular Biscuit) 510 33.000000
Sausage, Egg & Cheese McGriddles with Egg Whites 500 26.000000
Sausage Biscuit (Large Biscuit) 480 31.000000
Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) 470 25.000000
Southern Style Chicken Biscuit (Large Biscuit) 470 24.000000
Bacon, Egg & Cheese McGriddles 460 21.000000
Cinnamon Melts 460 19.000000
Sausage Biscuit with Egg Whites (Regular Biscuit) 460 27.000000
Bacon, Egg & Cheese Biscuit (Regular Biscuit) 460 26.000000
Sausage McMuffin with Egg 450 28.000000
Sausage Biscuit (Regular Biscuit) 430 27.000000
Steak & Egg McMuffin 430 23.000000
Sausage McGriddles 420 22.000000
Southern Style Chicken Biscuit (Regular Biscuit) 410 20.000000
Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) 410 20.000000
Bacon, Egg & Cheese McGriddles with Egg Whites 400 15.000000
Sausage McMuffin with Egg Whites 400 23.000000
Sausage McMuffin 370 23.000000
Hotcakes 350 9.000000
Sausage Burrito 300 16.000000
Egg McMuffin 300 13.000000
Fruit & Maple Oatmeal 290 4.000000
Fruit & Maple Oatmeal without Brown Sugar 260 4.000000
Egg White Delight 250 8.000000
Hash Brown 150 9.000000
2 . Beef & Pork
Item Calories Total Fat
Double Quarter Pounder with Cheese 750 43.000000
Bacon Clubhouse Burger 720 40.000000
Quarter Pounder with Bacon Habanero Ranch 610 31.000000
Quarter Pounder with Bacon & Cheese 600 29.000000
Quarter Pounder Deluxe 540 27.000000
Big Mac 530 27.000000
Quarter Pounder with Cheese 520 26.000000
McRib 500 26.000000
Bacon McDouble 440 22.000000
Double Cheeseburger 430 21.000000
Daily Double 430 22.000000
Jalapeño Double 430 23.000000
McDouble 380 17.000000
Cheeseburger 290 11.000000
Hamburger 240 8.000000
3 . Chicken & Fish
Item Calories Total Fat
Chicken McNuggets (40 piece) 1880 118.000000
Chicken McNuggets (20 piece) 940 59.000000
Bacon Clubhouse Crispy Chicken Sandwich 750 38.000000
Premium Crispy Chicken Club Sandwich 670 33.000000
Premium McWrap Southwest Chicken (Crispy Chicken) 670 33.000000
Premium McWrap Chicken & Bacon (Crispy Chicken) 630 32.000000
Premium McWrap Chicken & Ranch (Crispy Chicken) 610 31.000000
Premium Crispy Chicken Ranch BLT Sandwich 610 28.000000
Bacon Clubhouse Grilled Chicken Sandwich 590 25.000000
Premium McWrap Chicken Sweet Chili (Crispy Chicken) 540 23.000000
Premium McWrap Southwest Chicken (Grilled Chicken) 520 20.000000
Premium Crispy Chicken Classic Sandwich 510 22.000000
Premium Grilled Chicken Club Sandwich 510 20.000000
Bacon Cheddar McChicken 480 24.000000
Premium McWrap Chicken & Bacon (Grilled Chicken) 480 19.000000
Chicken McNuggets (10 piece) 470 30.000000
Premium McWrap Chicken & Ranch (Grilled Chicken) 450 18.000000
Premium Grilled Chicken Ranch BLT Sandwich 450 15.000000
Bacon Buffalo Ranch McChicken 430 21.000000
Southern Style Crispy Chicken Sandwich 430 19.000000
Filet-O-Fish 390 19.000000
Premium McWrap Chicken Sweet Chili (Grilled Chicken) 380 10.000000
Buffalo Ranch McChicken 360 16.000000
McChicken 360 16.000000
Premium Grilled Chicken Classic Sandwich 350 9.000000
Chicken McNuggets (6 piece) 280 18.000000
Chicken McNuggets (4 piece) 190 12.000000
4 . Salads
Item Calories Total Fat
Premium Southwest Salad with Crispy Chicken 450 22.000000
Premium Bacon Ranch Salad with Crispy Chicken 380 21.000000
Premium Southwest Salad with Grilled Chicken 290 8.000000
Premium Bacon Ranch Salad with Grilled Chicken 220 8.000000
Premium Bacon Ranch Salad (without Chicken) 140 7.000000
Premium Southwest Salad (without Chicken) 140 4.500000
5 . Snacks & Sides
Item Calories Total Fat
Large French Fries 510 24.000000
Ranch Snack Wrap (Crispy Chicken) 360 20.000000
Chipotle BBQ Snack Wrap (Crispy Chicken) 340 15.000000
Medium French Fries 340 16.000000
Honey Mustard Snack Wrap (Crispy Chicken) 330 15.000000
Ranch Snack Wrap (Grilled Chicken) 280 13.000000
Chipotle BBQ Snack Wrap (Grilled Chicken) 260 8.000000
Honey Mustard Snack Wrap (Grilled Chicken) 250 8.000000
Small French Fries 230 11.000000
Fruit 'n Yogurt Parfait 150 2.000000
Kids French Fries 110 5.000000
Side Salad 20 0.000000
Apple Slices 15 0.000000
6 . Desserts
Item Calories Total Fat
Hot Caramel Sundae 340 8.000000
Hot Fudge Sundae 330 9.000000
Strawberry Sundae 280 6.000000
Baked Apple Pie 250 13.000000
Chocolate Chip Cookie 160 8.000000
Oatmeal Raisin Cookie 150 6.000000
Kids Ice Cream Cone 45 1.500000
7 . Beverages
Item Calories Total Fat
Sprite (Large) 280 0.000000
Minute Maid Orange Juice (Large) 280 0.000000
Coca-Cola Classic (Large) 280 0.000000
Dr Pepper (Large) 270 0.000000
Sprite (Medium) 200 0.000000
Coca-Cola Classic (Medium) 200 0.000000
Dr Pepper (Medium) 190 0.000000
Minute Maid Orange Juice (Medium) 190 0.000000
Minute Maid Orange Juice (Small) 150 0.000000
Dr Pepper (Small) 140 0.000000
Sprite (Small) 140 0.000000
Coca-Cola Classic (Small) 140 0.000000
Fat Free Chocolate Milk Jug 130 0.000000
1% Low Fat Milk Jug 100 2.500000
Sprite (Child) 100 0.000000
Dr Pepper (Child) 100 0.000000
Coca-Cola Classic (Child) 100 0.000000
Minute Maid 100% Apple Juice Box 80 0.000000
Diet Dr Pepper (Medium) 0 0.000000
Diet Dr Pepper (Child) 0 0.000000
Diet Dr Pepper (Large) 0 0.000000
Diet Dr Pepper (Small) 0 0.000000
Diet Coke (Child) 0 0.000000
Diet Coke (Large) 0 0.000000
Diet Coke (Medium) 0 0.000000
Diet Coke (Small) 0 0.000000
Dasani Water Bottle 0 0.000000
8 . Coffee & Tea
Item Calories Total Fat
Frappé Chocolate Chip (Large) 760 31.000000
Frappé Mocha (Large) 670 26.000000
Frappé Caramel (Large) 670 27.000000
Frappé Chocolate Chip (Medium) 630 26.000000
Frappé Caramel (Medium) 550 23.000000
Frappé Mocha (Medium) 550 22.000000
Hot Chocolate (Large) 540 20.000000
Frappé Chocolate Chip (Small) 530 23.000000
Mocha (Large) 500 17.000000
Caramel Mocha (Large) 480 17.000000
Iced Mocha (Large) 480 16.000000
Iced Caramel Mocha (Large) 460 16.000000
Frappé Caramel (Small) 450 19.000000
Frappé Mocha (Small) 450 18.000000
Hot Chocolate (Medium) 440 16.000000
Hazelnut Latte (Large) 430 14.000000
Caramel Latte (Large) 430 14.000000
French Vanilla Latte (Large) 420 14.000000
Mocha (Medium) 410 14.000000
Hot Chocolate with Nonfat Milk (Large) 400 3.500000
Iced Mocha with Nonfat Milk (Large) 390 6.000000
Caramel Mocha (Medium) 390 14.000000
Mocha with Nonfat Milk (Large) 390 4.000000
Iced Nonfat Caramel Mocha (Large) 370 6.000000
Nonfat Caramel Mocha (Large) 370 3.500000
Hot Chocolate (Small) 360 13.000000
Iced Mocha (Medium) 350 13.000000
Mocha (Small) 340 11.000000
Hot Chocolate with Nonfat Milk (Medium) 340 3.500000
Caramel Latte (Medium) 340 10.000000
Iced Caramel Mocha (Medium) 340 13.000000
Hazelnut Latte (Medium) 330 10.000000
French Vanilla Latte (Medium) 330 10.000000
Latte with Sugar Free French Vanilla Syrup (Large) 330 14.000000
Mocha with Nonfat Milk (Medium) 330 3.500000
Caramel Mocha (Small) 320 11.000000
Nonfat Caramel Mocha (Medium) 310 3.500000
Nonfat Hazelnut Latte (Large) 310 0.500000
Nonfat Caramel Latte (Large) 310 0.500000
Nonfat French Vanilla Latte (Large) 300 0.500000
Iced Mocha with Nonfat Milk (Medium) 290 5.000000
Iced Mocha (Small) 290 11.000000
Latte (Large) 280 14.000000
Iced Caramel Mocha (Small) 280 11.000000
Hot Chocolate with Nonfat Milk (Small) 280 3.500000
Regular Iced Coffee (Large) 270 9.000000
Iced Nonfat Caramel Mocha (Medium) 270 5.000000
Mocha with Nonfat Milk (Small) 270 3.500000
Hazelnut Latte (Small) 270 9.000000
Caramel Latte (Small) 270 9.000000
Latte with Sugar Free French Vanilla Syrup (Medium) 260 10.000000
French Vanilla Latte (Small) 260 9.000000
Caramel Iced Coffee (Large) 260 9.000000
Nonfat Caramel Mocha (Small) 250 3.500000
Nonfat Caramel Latte (Medium) 250 0.000000
Nonfat Hazelnut Latte (Medium) 250 0.000000
Hazelnut Iced Coffee (Large) 250 9.000000
French Vanilla Iced Coffee (Large) 240 9.000000
Iced Mocha with Nonfat Milk (Small) 240 5.000000
Nonfat French Vanilla Latte (Medium) 240 0.000000
Iced Nonfat Caramel Mocha (Small) 230 5.000000
Nonfat Latte with Sugar Free French Vanilla Syrup (Large) 220 0.500000
Sweet Tea (Large) 220 0.000000
Latte with Sugar Free French Vanilla Syrup (Small) 210 9.000000
Latte (Medium) 210 10.000000
Nonfat Caramel Latte (Small) 200 0.000000
Nonfat Hazelnut Latte (Small) 200 0.000000
Regular Iced Coffee (Medium) 190 7.000000
Nonfat French Vanilla Latte (Small) 190 0.000000
Caramel Iced Coffee (Medium) 180 7.000000
Hazelnut Iced Coffee (Medium) 180 7.000000
Sweet Tea (Medium) 180 0.000000
Latte (Small) 170 9.000000
Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) 170 0.000000
Nonfat Latte (Large) 170 0.500000
French Vanilla Iced Coffee (Medium) 170 7.000000
Iced Coffee with Sugar Free French Vanilla Syrup (Large) 160 9.000000
Sweet Tea (Small) 150 0.000000
Regular Iced Coffee (Small) 140 4.500000
Nonfat Latte with Sugar Free French Vanilla Syrup (Small) 140 0.000000
Hazelnut Iced Coffee (Small) 130 4.500000
Caramel Iced Coffee (Small) 130 4.500000
Nonfat Latte (Medium) 130 0.000000
French Vanilla Iced Coffee (Small) 120 4.500000
Iced Coffee with Sugar Free French Vanilla Syrup (Medium) 120 7.000000
Sweet Tea (Child) 110 0.000000
Nonfat Latte (Small) 100 0.000000
Iced Coffee with Sugar Free French Vanilla Syrup (Small) 80 4.500000
Coffee (Large) 0 0.000000
Coffee (Medium) 0 0.000000
Coffee (Small) 0 0.000000
Iced Tea (Medium) 0 0.000000
Iced Tea (Child) 0 0.000000
Iced Tea (Large) 0 0.000000
Iced Tea (Small) 0 0.000000
9 . Smoothies & Shakes
Item Calories Total Fat
McFlurry with M&M’s Candies (Medium) 930 33.000000
Strawberry Shake (Large) 850 24.000000
Chocolate Shake (Large) 850 23.000000
Vanilla Shake (Large) 820 23.000000
Shamrock Shake (Large) 820 23.000000
McFlurry with Reese's Peanut Butter Cups (Medium) 810 32.000000
Chocolate Shake (Medium) 700 20.000000
McFlurry with Oreo Cookies (Medium) 690 23.000000
Strawberry Shake (Medium) 690 20.000000
Vanilla Shake (Medium) 660 19.000000
Shamrock Shake (Medium) 660 19.000000
McFlurry with M&M’s Candies (Small) 650 23.000000
Chocolate Shake (Small) 560 16.000000
Strawberry Shake (Small) 550 16.000000
Vanilla Shake (Small) 530 15.000000
McFlurry with Oreo Cookies (Small) 510 17.000000
McFlurry with M&M’s Candies (Snack) 430 15.000000
McFlurry with Reese's Peanut Butter Cups (Snack) 410 16.000000
Mango Pineapple Smoothie (Large) 340 1.000000
McFlurry with Oreo Cookies (Snack) 340 11.000000
Blueberry Pomegranate Smoothie (Large) 340 1.000000
Strawberry Banana Smoothie (Large) 330 1.000000
Blueberry Pomegranate Smoothie (Medium) 260 1.000000
Mango Pineapple Smoothie (Medium) 260 1.000000
Strawberry Banana Smoothie (Medium) 250 1.000000
Blueberry Pomegranate Smoothie (Small) 220 0.500000
Mango Pineapple Smoothie (Small) 210 0.500000
Strawberry Banana Smoothie (Small) 210 0.500000

Cholesterol and Protein

In [9]:
for list in lists:
    #items ascending=False
    items=data.query('Category == list').sort_values(by="Cholesterol", ascending=False)
    items_custom=items.iloc[:,[1,10,19]]
    
    #items ascending=True
    items_t=data.query('Category == list').sort_values(by="Cholesterol", ascending=True)
    items_custom_t=items_t.iloc[:,[1,10,19]]
    
    #Print Categories
    print(lists.index(list)+1,".",list)
    
    #Plotly Express
    p_express = px.scatter(items_custom, x="Protein",y='Cholesterol', color="Item",size='Cholesterol', 
                           template="plotly_dark",hover_name="Item")
    p_express.show()
    
    #Display Tables ranked by calories
    table=items_custom.iloc[:,[0,1, 2]].sort_values(by="Cholesterol", ascending=False).style.hide_index()
    #table=table.style.hide_index()
    display(table)
    
    #Matplotlib pyplot
    fig,ax=plt.subplots()
    x=items_custom_t.iloc[:,0]
    y=items_custom_t.iloc[:,1]
    ax.barh(x,y, linewidth=0, tick_label=x)
    plt.show()
1 . Breakfast
Item Cholesterol Protein
Big Breakfast with Hotcakes (Regular Biscuit) 575 36
Big Breakfast with Hotcakes (Large Biscuit) 575 36
Big Breakfast (Regular Biscuit) 555 28
Big Breakfast (Large Biscuit) 555 28
Steak & Egg McMuffin 300 26
Steak, Egg & Cheese Bagel 295 33
Sausage McMuffin with Egg 285 21
Steak & Egg Biscuit (Regular Biscuit) 280 25
Bacon, Egg & Cheese Bagel 275 30
Sausage, Egg & Cheese McGriddles 265 20
Egg McMuffin 260 17
Bacon, Egg & Cheese McGriddles 250 19
Sausage Biscuit with Egg (Large Biscuit) 250 18
Sausage Biscuit with Egg (Regular Biscuit) 250 18
Bacon, Egg & Cheese Biscuit (Large Biscuit) 250 19
Bacon, Egg & Cheese Biscuit (Regular Biscuit) 250 19
Sausage Burrito 115 12
Bacon, Egg & Cheese Bagel with Egg Whites 60 30
Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) 55 35
Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) 55 35
Sausage, Egg & Cheese McGriddles with Egg Whites 50 21
Sausage McMuffin with Egg Whites 50 21
Hotcakes and Sausage 50 15
Sausage McMuffin 45 14
Big Breakfast with Egg Whites (Large Biscuit) 35 26
Big Breakfast with Egg Whites (Regular Biscuit) 35 26
Sausage McGriddles 35 11
Bacon, Egg & Cheese McGriddles with Egg Whites 35 20
Sausage Biscuit with Egg Whites (Large Biscuit) 35 18
Sausage Biscuit with Egg Whites (Regular Biscuit) 35 18
Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) 35 20
Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) 35 20
Sausage Biscuit (Large Biscuit) 30 11
Sausage Biscuit (Regular Biscuit) 30 11
Southern Style Chicken Biscuit (Large Biscuit) 30 17
Southern Style Chicken Biscuit (Regular Biscuit) 30 17
Egg White Delight 25 18
Hotcakes 20 8
Cinnamon Melts 15 6
Fruit & Maple Oatmeal 5 5
Fruit & Maple Oatmeal without Brown Sugar 5 5
Hash Brown 0 1
2 . Beef & Pork
Item Cholesterol Protein
Double Quarter Pounder with Cheese 160 48
Bacon Clubhouse Burger 115 39
Quarter Pounder with Bacon & Cheese 105 37
Quarter Pounder with Bacon Habanero Ranch 105 37
Quarter Pounder with Cheese 95 30
Double Cheeseburger 90 24
Bacon McDouble 90 27
Big Mac 85 24
Quarter Pounder Deluxe 85 29
Daily Double 80 22
Jalapeño Double 80 22
McDouble 75 22
McRib 70 22
Cheeseburger 45 15
Hamburger 30 12
3 . Chicken & Fish
Item Cholesterol Protein
Chicken McNuggets (40 piece) 265 87
Chicken McNuggets (20 piece) 135 44
Bacon Clubhouse Grilled Chicken Sandwich 110 40
Premium Grilled Chicken Club Sandwich 105 40
Premium McWrap Chicken & Bacon (Grilled Chicken) 95 36
Premium Grilled Chicken Ranch BLT Sandwich 90 36
Bacon Clubhouse Crispy Chicken Sandwich 90 36
Premium Crispy Chicken Club Sandwich 85 36
Premium McWrap Chicken & Bacon (Crispy Chicken) 80 32
Premium McWrap Southwest Chicken (Grilled Chicken) 80 31
Premium McWrap Chicken & Ranch (Grilled Chicken) 80 30
Premium Crispy Chicken Ranch BLT Sandwich 70 32
Chicken McNuggets (10 piece) 65 22
Premium McWrap Chicken Sweet Chili (Grilled Chicken) 65 27
Bacon Cheddar McChicken 65 22
Premium Grilled Chicken Classic Sandwich 65 28
Premium McWrap Chicken & Ranch (Crispy Chicken) 65 27
Premium McWrap Southwest Chicken (Crispy Chicken) 60 27
Bacon Buffalo Ranch McChicken 50 20
Premium McWrap Chicken Sweet Chili (Crispy Chicken) 50 23
Premium Crispy Chicken Classic Sandwich 45 24
Southern Style Crispy Chicken Sandwich 45 21
Chicken McNuggets (6 piece) 40 13
Filet-O-Fish 40 15
Buffalo Ranch McChicken 35 14
McChicken 35 14
Chicken McNuggets (4 piece) 25 9
4 . Salads
Item Cholesterol Protein
Premium Bacon Ranch Salad with Grilled Chicken 85 29
Premium Bacon Ranch Salad with Crispy Chicken 70 25
Premium Southwest Salad with Grilled Chicken 70 27
Premium Southwest Salad with Crispy Chicken 50 23
Premium Bacon Ranch Salad (without Chicken) 25 9
Premium Southwest Salad (without Chicken) 10 6
5 . Snacks & Sides
Item Cholesterol Protein
Honey Mustard Snack Wrap (Grilled Chicken) 45 16
Ranch Snack Wrap (Grilled Chicken) 45 16
Chipotle BBQ Snack Wrap (Grilled Chicken) 40 16
Ranch Snack Wrap (Crispy Chicken) 40 15
Honey Mustard Snack Wrap (Crispy Chicken) 35 14
Chipotle BBQ Snack Wrap (Crispy Chicken) 30 14
Fruit 'n Yogurt Parfait 5 4
Small French Fries 0 2
Medium French Fries 0 4
Large French Fries 0 6
Kids French Fries 0 1
Side Salad 0 1
Apple Slices 0 0
6 . Desserts
Item Cholesterol Protein
Hot Caramel Sundae 30 7
Hot Fudge Sundae 25 8
Strawberry Sundae 25 6
Chocolate Chip Cookie 10 2
Oatmeal Raisin Cookie 10 2
Kids Ice Cream Cone 5 1
Baked Apple Pie 0 2
7 . Beverages
Item Cholesterol Protein
1% Low Fat Milk Jug 10 8
Fat Free Chocolate Milk Jug 5 9
Coca-Cola Classic (Medium) 0 0
Coca-Cola Classic (Large) 0 0
Coca-Cola Classic (Child) 0 0
Diet Coke (Small) 0 0
Diet Coke (Medium) 0 0
Diet Coke (Large) 0 0
Diet Coke (Child) 0 0
Dr Pepper (Small) 0 0
Dr Pepper (Medium) 0 0
Dr Pepper (Large) 0 0
Dr Pepper (Child) 0 0
Diet Dr Pepper (Small) 0 2
Diet Dr Pepper (Medium) 0 3
Diet Dr Pepper (Child) 0 1
Sprite (Small) 0 0
Sprite (Medium) 0 0
Sprite (Large) 0 0
Sprite (Child) 0 0
Minute Maid 100% Apple Juice Box 0 0
Minute Maid Orange Juice (Small) 0 2
Minute Maid Orange Juice (Medium) 0 3
Minute Maid Orange Juice (Large) 0 4
Diet Dr Pepper (Large) 0 4
Coca-Cola Classic (Small) 0 0
Dasani Water Bottle 0 0
8 . Coffee & Tea
Item Cholesterol Protein
Frappé Chocolate Chip (Large) 95 12
Frappé Caramel (Large) 95 11
Frappé Mocha (Large) 90 11
Frappé Chocolate Chip (Medium) 80 9
Frappé Caramel (Medium) 80 9
Frappé Mocha (Medium) 75 9
Frappé Mocha (Small) 65 7
Frappé Caramel (Small) 65 7
Frappé Chocolate Chip (Small) 65 8
Hot Chocolate (Large) 60 17
Iced Caramel Mocha (Large) 50 13
Mocha (Large) 50 16
Caramel Mocha (Large) 50 16
Iced Mocha (Large) 50 14
Hot Chocolate (Medium) 50 14
Hazelnut Latte (Large) 40 15
Mocha (Medium) 40 13
Iced Caramel Mocha (Medium) 40 9
Iced Mocha (Medium) 40 9
Latte (Large) 40 15
Caramel Latte (Large) 40 15
French Vanilla Latte (Large) 40 15
Hot Chocolate (Small) 40 11
Caramel Mocha (Medium) 40 12
Latte with Sugar Free French Vanilla Syrup (Large) 40 15
Iced Coffee with Sugar Free French Vanilla Syrup (Large) 35 2
Caramel Mocha (Small) 35 10
Mocha (Small) 35 10
Iced Mocha (Small) 35 8
Iced Caramel Mocha (Small) 35 8
Regular Iced Coffee (Large) 35 2
Caramel Iced Coffee (Large) 35 2
Hazelnut Iced Coffee (Large) 35 2
French Vanilla Iced Coffee (Large) 35 2
Latte with Sugar Free French Vanilla Syrup (Medium) 30 12
Hazelnut Latte (Medium) 30 11
Latte (Medium) 30 11
Caramel Latte (Medium) 30 11
French Vanilla Latte (Medium) 30 11
Caramel Latte (Small) 25 9
Iced Nonfat Caramel Mocha (Large) 25 14
Latte (Small) 25 9
Latte with Sugar Free French Vanilla Syrup (Small) 25 9
Hazelnut Iced Coffee (Medium) 25 1
Iced Mocha with Nonfat Milk (Large) 25 14
Hazelnut Latte (Small) 25 9
Caramel Iced Coffee (Medium) 25 1
Regular Iced Coffee (Medium) 25 1
French Vanilla Iced Coffee (Medium) 25 1
French Vanilla Latte (Small) 25 9
Iced Coffee with Sugar Free French Vanilla Syrup (Medium) 25 1
Mocha with Nonfat Milk (Large) 20 17
Iced Mocha with Nonfat Milk (Small) 20 8
Iced Mocha with Nonfat Milk (Medium) 20 10
Nonfat Caramel Mocha (Large) 20 17
Iced Nonfat Caramel Mocha (Small) 20 8
Iced Nonfat Caramel Mocha (Medium) 20 10
Hot Chocolate with Nonfat Milk (Large) 20 19
Iced Coffee with Sugar Free French Vanilla Syrup (Small) 15 1
French Vanilla Iced Coffee (Small) 15 1
Mocha with Nonfat Milk (Small) 15 11
Mocha with Nonfat Milk (Medium) 15 13
Nonfat Caramel Mocha (Small) 15 10
Nonfat Caramel Mocha (Medium) 15 13
Hot Chocolate with Nonfat Milk (Small) 15 12
Hot Chocolate with Nonfat Milk (Medium) 15 14
Regular Iced Coffee (Small) 15 1
Caramel Iced Coffee (Small) 15 1
Hazelnut Iced Coffee (Small) 15 1
Nonfat French Vanilla Latte (Large) 10 16
Nonfat Caramel Latte (Large) 10 16
Nonfat Latte with Sugar Free French Vanilla Syrup (Large) 10 16
Nonfat Latte (Large) 10 16
Nonfat Hazelnut Latte (Large) 10 16
Nonfat Hazelnut Latte (Medium) 5 12
Nonfat Caramel Latte (Small) 5 10
Nonfat Caramel Latte (Medium) 5 12
Nonfat Hazelnut Latte (Small) 5 10
Nonfat Latte (Medium) 5 12
Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) 5 12
Nonfat Latte (Small) 5 10
Nonfat Latte with Sugar Free French Vanilla Syrup (Small) 5 10
Nonfat French Vanilla Latte (Medium) 5 12
Nonfat French Vanilla Latte (Small) 5 10
Sweet Tea (Large) 0 1
Iced Tea (Large) 0 0
Iced Tea (Child) 0 0
Sweet Tea (Small) 0 1
Sweet Tea (Medium) 0 1
Coffee (Large) 0 0
Sweet Tea (Child) 0 0
Coffee (Small) 0 0
Coffee (Medium) 0 0
Iced Tea (Medium) 0 0
Iced Tea (Small) 0 0
9 . Smoothies & Shakes
Item Cholesterol Protein
Strawberry Shake (Large) 90 18
Vanilla Shake (Large) 90 18
Shamrock Shake (Large) 90 18
Chocolate Shake (Large) 85 19
McFlurry with M&M’s Candies (Medium) 75 20
Shamrock Shake (Medium) 75 14
Vanilla Shake (Medium) 75 14
Strawberry Shake (Medium) 75 15
Chocolate Shake (Medium) 75 15
Strawberry Shake (Small) 60 12
McFlurry with Reese's Peanut Butter Cups (Medium) 60 21
Chocolate Shake (Small) 60 12
Vanilla Shake (Small) 60 11
McFlurry with Oreo Cookies (Medium) 55 15
McFlurry with M&M’s Candies (Small) 50 13
McFlurry with Oreo Cookies (Small) 45 12
McFlurry with M&M’s Candies (Snack) 35 9
McFlurry with Oreo Cookies (Snack) 30 8
McFlurry with Reese's Peanut Butter Cups (Snack) 30 10
Blueberry Pomegranate Smoothie (Medium) 5 3
Mango Pineapple Smoothie (Large) 5 4
Mango Pineapple Smoothie (Medium) 5 3
Mango Pineapple Smoothie (Small) 5 2
Strawberry Banana Smoothie (Large) 5 5
Strawberry Banana Smoothie (Medium) 5 4
Strawberry Banana Smoothie (Small) 5 3
Blueberry Pomegranate Smoothie (Large) 5 4
Blueberry Pomegranate Smoothie (Small) 5 2

Carbohydrates and Sugars

In [10]:
for list in lists:
    #items ascending=False
    items=data.query('Category == list').sort_values(by="Carbohydrates", ascending=False)
    items_custom=items.iloc[:,[1,14,18]]
    
    #items ascending=True
    items_t=data.query('Category == list').sort_values(by="Carbohydrates", ascending=True)
    items_custom_t=items_t.iloc[:,[1,14,18]]
    
    #Print Categories
    print(lists.index(list)+1,".",list)
    
    #Plotly Express
    p_express = px.scatter(items_custom, x="Sugars",y='Carbohydrates', color="Item",size='Carbohydrates', 
                           template="plotly_dark",hover_name="Item")
    p_express.show()
    
    #Display Tables ranked by calories
    table=items_custom.iloc[:,[0,1,2]].sort_values(by="Carbohydrates", ascending=False).style.hide_index()
    #table=table.style.hide_index()
    display(table)
    
    #Matplotlib pyplot
    fig,ax=plt.subplots()
    x=items_custom_t.iloc[:,0]
    y=items_custom_t.iloc[:,1]
    ax.barh(x,y, linewidth=0, tick_label=x)
    plt.show()
1 . Breakfast
Item Carbohydrates Sugars
Big Breakfast with Hotcakes (Large Biscuit) 116 17
Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) 115 18
Big Breakfast with Hotcakes (Regular Biscuit) 111 17
Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) 110 17
Cinnamon Melts 66 32
Hotcakes and Sausage 61 14
Hotcakes 60 14
Fruit & Maple Oatmeal 58 32
Bacon, Egg & Cheese Bagel 57 7
Steak, Egg & Cheese Bagel 56 7
Big Breakfast (Large Biscuit) 56 3
Big Breakfast with Egg Whites (Large Biscuit) 55 4
Bacon, Egg & Cheese Bagel with Egg Whites 55 8
Big Breakfast (Regular Biscuit) 51 3
Big Breakfast with Egg Whites (Regular Biscuit) 50 3
Fruit & Maple Oatmeal without Brown Sugar 49 18
Sausage, Egg & Cheese McGriddles 48 15
Bacon, Egg & Cheese McGriddles 48 15
Bacon, Egg & Cheese McGriddles with Egg Whites 47 16
Southern Style Chicken Biscuit (Large Biscuit) 46 4
Sausage, Egg & Cheese McGriddles with Egg Whites 46 15
Sausage McGriddles 44 15
Bacon, Egg & Cheese Biscuit (Large Biscuit) 43 4
Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) 42 4
Sausage Biscuit with Egg (Large Biscuit) 42 3
Southern Style Chicken Biscuit (Regular Biscuit) 41 3
Sausage Biscuit with Egg Whites (Large Biscuit) 40 3
Sausage Biscuit (Large Biscuit) 39 3
Steak & Egg Biscuit (Regular Biscuit) 38 3
Bacon, Egg & Cheese Biscuit (Regular Biscuit) 38 3
Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) 36 3
Sausage Biscuit with Egg (Regular Biscuit) 36 2
Sausage Biscuit (Regular Biscuit) 34 2
Sausage Biscuit with Egg Whites (Regular Biscuit) 34 3
Steak & Egg McMuffin 31 3
Egg McMuffin 31 3
Sausage McMuffin with Egg Whites 30 2
Sausage McMuffin with Egg 30 2
Egg White Delight 30 3
Sausage McMuffin 29 2
Sausage Burrito 26 2
Hash Brown 15 0
2 . Beef & Pork
Item Carbohydrates Sugars
Bacon Clubhouse Burger 51 14
Quarter Pounder with Bacon & Cheese 48 12
Big Mac 47 9
Quarter Pounder with Bacon Habanero Ranch 46 10
Quarter Pounder Deluxe 45 9
McRib 44 11
Double Quarter Pounder with Cheese 42 10
Quarter Pounder with Cheese 41 10
Double Cheeseburger 35 7
Bacon McDouble 35 7
Jalapeño Double 35 6
McDouble 34 7
Daily Double 34 7
Cheeseburger 33 7
Hamburger 32 6
3 . Chicken & Fish
Item Carbohydrates Sugars
Chicken McNuggets (40 piece) 118 1
Premium McWrap Southwest Chicken (Crispy Chicken) 68 12
Bacon Clubhouse Crispy Chicken Sandwich 65 16
Premium McWrap Chicken Sweet Chili (Crispy Chicken) 61 14
Chicken McNuggets (20 piece) 59 0
Premium Crispy Chicken Club Sandwich 58 11
Premium Crispy Chicken Ranch BLT Sandwich 57 11
Premium McWrap Chicken & Bacon (Crispy Chicken) 56 7
Premium McWrap Chicken & Ranch (Crispy Chicken) 56 8
Premium McWrap Southwest Chicken (Grilled Chicken) 55 10
Premium Crispy Chicken Classic Sandwich 55 10
Bacon Clubhouse Grilled Chicken Sandwich 51 14
Premium McWrap Chicken Sweet Chili (Grilled Chicken) 47 12
Premium Grilled Chicken Club Sandwich 44 9
Bacon Cheddar McChicken 43 6
Southern Style Crispy Chicken Sandwich 43 7
Premium Grilled Chicken Ranch BLT Sandwich 43 9
Premium Grilled Chicken Classic Sandwich 42 8
Premium McWrap Chicken & Bacon (Grilled Chicken) 42 6
Premium McWrap Chicken & Ranch (Grilled Chicken) 42 6
Bacon Buffalo Ranch McChicken 41 6
Buffalo Ranch McChicken 40 5
McChicken 40 5
Filet-O-Fish 39 5
Chicken McNuggets (10 piece) 30 0
Chicken McNuggets (6 piece) 18 0
Chicken McNuggets (4 piece) 12 0
4 . Salads
Item Carbohydrates Sugars
Premium Southwest Salad with Crispy Chicken 42 12
Premium Southwest Salad with Grilled Chicken 28 10
Premium Bacon Ranch Salad with Crispy Chicken 22 5
Premium Southwest Salad (without Chicken) 20 6
Premium Bacon Ranch Salad (without Chicken) 10 4
Premium Bacon Ranch Salad with Grilled Chicken 8 4
5 . Snacks & Sides
Item Carbohydrates Sugars
Large French Fries 67 0
Medium French Fries 44 0
Chipotle BBQ Snack Wrap (Crispy Chicken) 37 8
Honey Mustard Snack Wrap (Crispy Chicken) 34 3
Ranch Snack Wrap (Crispy Chicken) 32 3
Chipotle BBQ Snack Wrap (Grilled Chicken) 30 7
Small French Fries 30 0
Fruit 'n Yogurt Parfait 30 23
Honey Mustard Snack Wrap (Grilled Chicken) 27 2
Ranch Snack Wrap (Grilled Chicken) 25 2
Kids French Fries 15 0
Side Salad 4 2
Apple Slices 4 3
6 . Desserts
Item Carbohydrates Sugars
Hot Caramel Sundae 60 43
Hot Fudge Sundae 53 48
Strawberry Sundae 49 45
Baked Apple Pie 32 13
Oatmeal Raisin Cookie 22 13
Chocolate Chip Cookie 21 15
Kids Ice Cream Cone 7 6
7 . Beverages
Item Carbohydrates Sugars
Coca-Cola Classic (Large) 76 76
Sprite (Large) 74 74
Dr Pepper (Large) 72 70
Minute Maid Orange Juice (Large) 65 58
Coca-Cola Classic (Medium) 55 55
Sprite (Medium) 54 54
Dr Pepper (Medium) 53 51
Minute Maid Orange Juice (Medium) 44 39
Coca-Cola Classic (Small) 39 39
Dr Pepper (Small) 37 35
Sprite (Small) 37 37
Minute Maid Orange Juice (Small) 34 30
Coca-Cola Classic (Child) 28 28
Sprite (Child) 27 27
Dr Pepper (Child) 27 26
Fat Free Chocolate Milk Jug 23 22
Minute Maid 100% Apple Juice Box 21 19
1% Low Fat Milk Jug 12 12
Diet Dr Pepper (Medium) 0 0
Diet Dr Pepper (Child) 0 0
Diet Dr Pepper (Large) 0 0
Diet Dr Pepper (Small) 0 0
Diet Coke (Child) 0 0
Diet Coke (Large) 0 0
Diet Coke (Medium) 0 0
Diet Coke (Small) 0 0
Dasani Water Bottle 0 0
8 . Coffee & Tea
Item Carbohydrates Sugars
Frappé Chocolate Chip (Large) 111 99
Frappé Mocha (Large) 98 88
Frappé Caramel (Large) 96 88
Frappé Chocolate Chip (Medium) 91 81
Frappé Mocha (Medium) 80 71
Frappé Caramel (Medium) 79 71
Frappé Chocolate Chip (Small) 76 67
Hot Chocolate with Nonfat Milk (Large) 74 69
Mocha with Nonfat Milk (Large) 73 64
Hot Chocolate (Large) 73 68
Mocha (Large) 72 63
Iced Mocha with Nonfat Milk (Large) 71 62
Iced Mocha (Large) 70 62
Nonfat Caramel Mocha (Large) 67 61
Caramel Mocha (Large) 66 60
Iced Nonfat Caramel Mocha (Large) 65 59
Frappé Mocha (Small) 65 57
Iced Caramel Mocha (Large) 65 59
Frappé Caramel (Small) 64 57
Nonfat Caramel Latte (Large) 63 59
Nonfat Hazelnut Latte (Large) 63 59
Hazelnut Latte (Large) 62 58
Caramel Latte (Large) 62 59
Hot Chocolate (Medium) 61 56
Hot Chocolate with Nonfat Milk (Medium) 61 57
Mocha (Medium) 60 53
French Vanilla Latte (Large) 60 56
Mocha with Nonfat Milk (Medium) 60 53
Nonfat French Vanilla Latte (Large) 60 56
Nonfat Caramel Mocha (Medium) 56 51
Caramel Mocha (Medium) 55 50
Sweet Tea (Large) 54 54
Nonfat Caramel Latte (Medium) 51 48
Nonfat Hazelnut Latte (Medium) 51 48
Iced Mocha with Nonfat Milk (Medium) 50 43
Iced Mocha (Medium) 50 43
Hazelnut Latte (Medium) 50 47
Hot Chocolate with Nonfat Milk (Small) 50 46
Caramel Latte (Medium) 50 48
Hot Chocolate (Small) 50 45
Nonfat French Vanilla Latte (Medium) 49 46
Mocha (Small) 49 42
Mocha with Nonfat Milk (Small) 49 43
French Vanilla Latte (Medium) 48 45
Iced Nonfat Caramel Mocha (Medium) 47 41
Regular Iced Coffee (Large) 47 45
Iced Caramel Mocha (Medium) 46 41
Sweet Tea (Medium) 45 45
Nonfat Caramel Mocha (Small) 45 41
Caramel Mocha (Small) 45 40
Hazelnut Iced Coffee (Large) 43 41
Caramel Iced Coffee (Large) 43 42
Iced Mocha (Small) 41 34
Nonfat Caramel Latte (Small) 41 39
Iced Mocha with Nonfat Milk (Small) 41 35
French Vanilla Iced Coffee (Large) 41 39
Nonfat Hazelnut Latte (Small) 40 38
Hazelnut Latte (Small) 40 38
Caramel Latte (Small) 40 38
Nonfat French Vanilla Latte (Small) 39 37
Nonfat Latte with Sugar Free French Vanilla Syrup (Large) 38 21
French Vanilla Latte (Small) 38 36
Iced Nonfat Caramel Mocha (Small) 38 33
Iced Caramel Mocha (Small) 38 33
Latte with Sugar Free French Vanilla Syrup (Large) 37 20
Sweet Tea (Small) 36 36
Regular Iced Coffee (Medium) 31 30
Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) 30 16
Hazelnut Iced Coffee (Medium) 29 28
Latte with Sugar Free French Vanilla Syrup (Medium) 29 15
Caramel Iced Coffee (Medium) 29 28
Sweet Tea (Child) 27 27
French Vanilla Iced Coffee (Medium) 27 26
Nonfat Latte (Large) 25 21
Latte with Sugar Free French Vanilla Syrup (Small) 24 12
Nonfat Latte with Sugar Free French Vanilla Syrup (Small) 24 13
Latte (Large) 24 20
Regular Iced Coffee (Small) 23 22
Caramel Iced Coffee (Small) 22 21
Hazelnut Iced Coffee (Small) 21 20
French Vanilla Iced Coffee (Small) 20 19
Nonfat Latte (Medium) 19 16
Iced Coffee with Sugar Free French Vanilla Syrup (Large) 18 2
Latte (Medium) 18 15
Latte (Small) 15 12
Nonfat Latte (Small) 15 13
Iced Coffee with Sugar Free French Vanilla Syrup (Medium) 12 2
Iced Coffee with Sugar Free French Vanilla Syrup (Small) 9 1
Iced Tea (Large) 0 0
Iced Tea (Child) 0 0
Iced Tea (Medium) 0 0
Coffee (Small) 0 0
Coffee (Medium) 0 0
Coffee (Large) 0 0
Iced Tea (Small) 0 0
9 . Smoothies & Shakes
Item Carbohydrates Sugars
Chocolate Shake (Large) 141 120
Strawberry Shake (Large) 140 123
McFlurry with M&M’s Candies (Medium) 139 128
Shamrock Shake (Large) 135 115
Vanilla Shake (Large) 135 101
McFlurry with Reese's Peanut Butter Cups (Medium) 114 103
Strawberry Shake (Medium) 114 100
Chocolate Shake (Medium) 114 97
Vanilla Shake (Medium) 109 81
Shamrock Shake (Medium) 109 93
McFlurry with Oreo Cookies (Medium) 106 85
McFlurry with M&M’s Candies (Small) 96 89
Chocolate Shake (Small) 91 77
Strawberry Shake (Small) 90 79
Vanilla Shake (Small) 86 63
McFlurry with Oreo Cookies (Small) 80 64
Blueberry Pomegranate Smoothie (Large) 79 70
Mango Pineapple Smoothie (Large) 78 72
Strawberry Banana Smoothie (Large) 74 70
McFlurry with M&M’s Candies (Snack) 64 59
Blueberry Pomegranate Smoothie (Medium) 62 54
Mango Pineapple Smoothie (Medium) 61 56
Strawberry Banana Smoothie (Medium) 58 54
McFlurry with Reese's Peanut Butter Cups (Snack) 57 51
McFlurry with Oreo Cookies (Snack) 53 43
Mango Pineapple Smoothie (Small) 50 46
Blueberry Pomegranate Smoothie (Small) 50 44
Strawberry Banana Smoothie (Small) 47 44
In [11]:
for list in lists:
    #items ascending=False
    items=data.query('Category == list').sort_values(by="Calories from Fat", ascending=False)
    items_custom=items.iloc[:,[1,4,12]]
    
    #items ascending=True
    items_t=data.query('Category == list').sort_values(by="Calories from Fat", ascending=True)
    items_custom_t=items_t.iloc[:,[1,14,12]]
    
    #Print Categories
    print(lists.index(list)+1,".",list)
    
    #Plotly Express
    p_express = px.scatter(items_custom, x="Sodium",y='Calories from Fat', color="Item",size='Calories from Fat', 
                           template="plotly_dark",hover_name="Item")
    p_express.show()
    
    #Display Tables ranked by calories
    table=items_custom.iloc[:,[0,1,2]].sort_values(by="Calories from Fat", ascending=False).style.hide_index()
    #table=table.style.hide_index()
    display(table)
    
    #Matplotlib pyplot
    fig,ax=plt.subplots()
    x=items_custom_t.iloc[:,0]
    y=items_custom_t.iloc[:,1]
    ax.barh(x,y, linewidth=0, tick_label=x)
    plt.show()
1 . Breakfast
Item Calories from Fat Sodium
Big Breakfast with Hotcakes (Large Biscuit) 540 2260
Big Breakfast with Hotcakes (Regular Biscuit) 510 2150
Big Breakfast (Large Biscuit) 470 1680
Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) 450 2290
Big Breakfast (Regular Biscuit) 430 1560
Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) 410 2170
Big Breakfast with Egg Whites (Large Biscuit) 370 1700
Big Breakfast with Egg Whites (Regular Biscuit) 330 1590
Sausage Biscuit with Egg (Large Biscuit) 330 1280
Steak, Egg & Cheese Bagel 310 1510
Steak & Egg Biscuit (Regular Biscuit) 290 1470
Sausage Biscuit with Egg (Regular Biscuit) 290 1170
Sausage Biscuit (Large Biscuit) 280 1190
Sausage Biscuit with Egg Whites (Large Biscuit) 280 1290
Sausage, Egg & Cheese McGriddles 280 1320
Bacon, Egg & Cheese Bagel 280 1480
Bacon, Egg & Cheese Biscuit (Large Biscuit) 270 1410
Sausage McMuffin with Egg 250 860
Sausage Biscuit with Egg Whites (Regular Biscuit) 250 1180
Sausage Biscuit (Regular Biscuit) 240 1080
Bacon, Egg & Cheese Bagel with Egg Whites 230 1480
Sausage, Egg & Cheese McGriddles with Egg Whites 230 1320
Bacon, Egg & Cheese Biscuit (Regular Biscuit) 230 1300
Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit) 220 1420
Southern Style Chicken Biscuit (Large Biscuit) 220 1290
Hotcakes and Sausage 210 930
Steak & Egg McMuffin 210 960
Sausage McMuffin with Egg Whites 210 880
Sausage McGriddles 200 1030
Sausage McMuffin 200 780
Bacon, Egg & Cheese McGriddles 190 1250
Bacon, Egg & Cheese Biscuit with Egg Whites (Regular Biscuit) 180 1300
Southern Style Chicken Biscuit (Regular Biscuit) 180 1180
Cinnamon Melts 170 370
Sausage Burrito 150 790
Bacon, Egg & Cheese McGriddles with Egg Whites 140 1250
Egg McMuffin 120 750
Hotcakes 80 590
Hash Brown 80 310
Egg White Delight 70 770
Fruit & Maple Oatmeal without Brown Sugar 40 115
Fruit & Maple Oatmeal 35 160
2 . Beef & Pork
Item Calories from Fat Sodium
Double Quarter Pounder with Cheese 380 1280
Bacon Clubhouse Burger 360 1470
Quarter Pounder with Bacon Habanero Ranch 280 1180
Quarter Pounder with Bacon & Cheese 260 1440
Quarter Pounder Deluxe 250 960
Big Mac 240 960
Quarter Pounder with Cheese 240 1100
McRib 240 980
Jalapeño Double 210 1030
Bacon McDouble 200 1110
Daily Double 200 760
Double Cheeseburger 190 1040
McDouble 150 840
Cheeseburger 100 680
Hamburger 70 480
3 . Chicken & Fish
Item Calories from Fat Sodium
Chicken McNuggets (40 piece) 1060 3600
Chicken McNuggets (20 piece) 530 1800
Bacon Clubhouse Crispy Chicken Sandwich 340 1720
Premium Crispy Chicken Club Sandwich 300 1410
Premium McWrap Southwest Chicken (Crispy Chicken) 300 1480
Premium McWrap Chicken & Bacon (Crispy Chicken) 280 1540
Premium McWrap Chicken & Ranch (Crispy Chicken) 280 1340
Chicken McNuggets (10 piece) 270 900
Premium Crispy Chicken Ranch BLT Sandwich 250 1400
Bacon Clubhouse Grilled Chicken Sandwich 230 1560
Bacon Cheddar McChicken 220 1260
Premium McWrap Chicken Sweet Chili (Crispy Chicken) 200 1260
Premium Crispy Chicken Classic Sandwich 200 990
Bacon Buffalo Ranch McChicken 190 1260
Premium McWrap Southwest Chicken (Grilled Chicken) 180 1320
Premium Grilled Chicken Club Sandwich 180 1250
Premium McWrap Chicken & Bacon (Grilled Chicken) 170 1370
Southern Style Crispy Chicken Sandwich 170 910
Filet-O-Fish 170 590
Premium McWrap Chicken & Ranch (Grilled Chicken) 160 1170
Chicken McNuggets (6 piece) 160 540
Buffalo Ranch McChicken 150 990
McChicken 140 800
Premium Grilled Chicken Ranch BLT Sandwich 130 1230
Chicken McNuggets (4 piece) 110 360
Premium McWrap Chicken Sweet Chili (Grilled Chicken) 90 1090
Premium Grilled Chicken Classic Sandwich 80 820
4 . Salads
Item Calories from Fat Sodium
Premium Bacon Ranch Salad with Crispy Chicken 190 860
Premium Southwest Salad with Crispy Chicken 190 850
Premium Bacon Ranch Salad with Grilled Chicken 80 690
Premium Southwest Salad with Grilled Chicken 80 680
Premium Bacon Ranch Salad (without Chicken) 70 300
Premium Southwest Salad (without Chicken) 40 150
5 . Snacks & Sides
Item Calories from Fat Sodium
Large French Fries 220 290
Ranch Snack Wrap (Crispy Chicken) 180 810
Medium French Fries 140 190
Chipotle BBQ Snack Wrap (Crispy Chicken) 130 780
Honey Mustard Snack Wrap (Crispy Chicken) 130 730
Ranch Snack Wrap (Grilled Chicken) 120 720
Small French Fries 100 130
Chipotle BBQ Snack Wrap (Grilled Chicken) 70 700
Honey Mustard Snack Wrap (Grilled Chicken) 70 650
Kids French Fries 50 65
Fruit 'n Yogurt Parfait 20 70
Side Salad 0 10
Apple Slices 0 0
6 . Desserts
Item Calories from Fat Sodium
Baked Apple Pie 110 170
Hot Fudge Sundae 80 170
Chocolate Chip Cookie 70 90
Hot Caramel Sundae 70 150
Strawberry Sundae 60 85
Oatmeal Raisin Cookie 50 135
Kids Ice Cream Cone 10 20
7 . Beverages
Item Calories from Fat Sodium
1% Low Fat Milk Jug 20 125
Coca-Cola Classic (Medium) 0 5
Coca-Cola Classic (Large) 0 5
Coca-Cola Classic (Child) 0 0
Diet Coke (Small) 0 10
Diet Coke (Medium) 0 20
Diet Coke (Large) 0 35
Diet Coke (Child) 0 15
Dr Pepper (Small) 0 45
Dr Pepper (Medium) 0 65
Dr Pepper (Large) 0 90
Dr Pepper (Child) 0 30
Diet Dr Pepper (Small) 0 70
Diet Dr Pepper (Medium) 0 100
Coca-Cola Classic (Small) 0 0
Diet Dr Pepper (Child) 0 50
Sprite (Small) 0 30
Sprite (Medium) 0 45
Sprite (Large) 0 60
Sprite (Child) 0 25
Fat Free Chocolate Milk Jug 0 135
Minute Maid 100% Apple Juice Box 0 15
Minute Maid Orange Juice (Small) 0 0
Minute Maid Orange Juice (Medium) 0 0
Minute Maid Orange Juice (Large) 0 5
Diet Dr Pepper (Large) 0 140
Dasani Water Bottle 0 0
8 . Coffee & Tea
Item Calories from Fat Sodium
Frappé Chocolate Chip (Large) 280 200
Frappé Caramel (Large) 250 190
Frappé Chocolate Chip (Medium) 240 160
Frappé Mocha (Large) 240 190
Frappé Chocolate Chip (Small) 200 135
Frappé Caramel (Medium) 200 160
Frappé Mocha (Medium) 200 160
Hot Chocolate (Large) 180 280
Frappé Caramel (Small) 170 125
Frappé Mocha (Small) 160 125
Iced Caramel Mocha (Large) 150 250
Iced Mocha (Large) 150 220
Caramel Mocha (Large) 150 270
Mocha (Large) 150 240
Hot Chocolate (Medium) 140 220
Latte (Large) 120 180
Caramel Latte (Large) 120 180
Hazelnut Latte (Large) 120 180
Hot Chocolate (Small) 120 180
French Vanilla Latte (Large) 120 190
Caramel Mocha (Medium) 120 220
Latte with Sugar Free French Vanilla Syrup (Large) 120 240
Mocha (Medium) 120 190
Iced Caramel Mocha (Medium) 110 170
Iced Mocha (Medium) 110 150
Iced Mocha (Small) 100 125
Iced Caramel Mocha (Small) 100 140
Caramel Mocha (Small) 100 170
Mocha (Small) 100 150
French Vanilla Latte (Medium) 90 140
Hazelnut Latte (Medium) 90 140
Caramel Latte (Medium) 90 140
Latte with Sugar Free French Vanilla Syrup (Medium) 90 190
Latte (Medium) 90 140
Hazelnut Iced Coffee (Large) 80 75
Caramel Latte (Small) 80 115
Hazelnut Latte (Small) 80 115
Iced Coffee with Sugar Free French Vanilla Syrup (Large) 80 135
French Vanilla Iced Coffee (Large) 80 80
Latte with Sugar Free French Vanilla Syrup (Small) 80 150
French Vanilla Latte (Small) 80 115
Latte (Small) 80 115
Regular Iced Coffee (Large) 80 75
Caramel Iced Coffee (Large) 80 65
Hazelnut Iced Coffee (Medium) 60 50
Regular Iced Coffee (Medium) 60 50
Iced Coffee with Sugar Free French Vanilla Syrup (Medium) 60 90
French Vanilla Iced Coffee (Medium) 60 55
Caramel Iced Coffee (Medium) 60 50
Iced Nonfat Caramel Mocha (Large) 50 250
Iced Mocha with Nonfat Milk (Large) 50 220
Iced Mocha with Nonfat Milk (Medium) 45 150
Iced Mocha with Nonfat Milk (Small) 45 125
Iced Nonfat Caramel Mocha (Medium) 45 170
Iced Nonfat Caramel Mocha (Small) 45 140
French Vanilla Iced Coffee (Small) 40 40
Caramel Iced Coffee (Small) 40 35
Regular Iced Coffee (Small) 40 35
Iced Coffee with Sugar Free French Vanilla Syrup (Small) 40 65
Hazelnut Iced Coffee (Small) 40 35
Mocha with Nonfat Milk (Large) 35 240
Hot Chocolate with Nonfat Milk (Large) 35 280
Nonfat Caramel Mocha (Large) 35 270
Hot Chocolate with Nonfat Milk (Small) 30 180
Nonfat Caramel Mocha (Small) 30 170
Mocha with Nonfat Milk (Medium) 30 190
Nonfat Caramel Mocha (Medium) 30 210
Hot Chocolate with Nonfat Milk (Medium) 30 220
Mocha with Nonfat Milk (Small) 30 150
Nonfat Latte (Medium) 0 135
Nonfat Caramel Latte (Large) 0 180
Nonfat Hazelnut Latte (Small) 0 110
Nonfat Hazelnut Latte (Medium) 0 135
Nonfat Hazelnut Latte (Large) 0 180
Nonfat French Vanilla Latte (Small) 0 115
Nonfat French Vanilla Latte (Medium) 0 140
Nonfat French Vanilla Latte (Large) 0 180
Nonfat Latte with Sugar Free French Vanilla Syrup (Small) 0 150
Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) 0 180
Nonfat Latte with Sugar Free French Vanilla Syrup (Large) 0 240
Nonfat Latte (Large) 0 180
Sweet Tea (Child) 0 5
Nonfat Latte (Small) 0 110
Iced Tea (Medium) 0 10
Nonfat Caramel Latte (Medium) 0 135
Nonfat Caramel Latte (Small) 0 110
Coffee (Small) 0 0
Iced Tea (Large) 0 15
Iced Tea (Child) 0 5
Sweet Tea (Small) 0 10
Sweet Tea (Medium) 0 10
Sweet Tea (Large) 0 10
Coffee (Medium) 0 0
Coffee (Large) 0 0
Iced Tea (Small) 0 10
9 . Smoothies & Shakes
Item Calories from Fat Sodium
McFlurry with Reese's Peanut Butter Cups (Medium) 290 400
McFlurry with M&M’s Candies (Medium) 290 260
Strawberry Shake (Large) 210 260
McFlurry with M&M’s Candies (Small) 210 180
Shamrock Shake (Large) 210 260
Chocolate Shake (Large) 210 380
Vanilla Shake (Large) 210 260
McFlurry with Oreo Cookies (Medium) 200 380
Chocolate Shake (Medium) 180 300
Strawberry Shake (Medium) 180 210
Shamrock Shake (Medium) 170 210
Vanilla Shake (Medium) 170 200
Strawberry Shake (Small) 150 160
McFlurry with Reese's Peanut Butter Cups (Snack) 150 200
McFlurry with Oreo Cookies (Small) 150 280
Chocolate Shake (Small) 150 240
Vanilla Shake (Small) 140 160
McFlurry with M&M’s Candies (Snack) 140 120
McFlurry with Oreo Cookies (Snack) 100 190
Mango Pineapple Smoothie (Large) 10 60
Mango Pineapple Smoothie (Medium) 10 45
Strawberry Banana Smoothie (Large) 10 80
Blueberry Pomegranate Smoothie (Large) 10 65
Blueberry Pomegranate Smoothie (Medium) 5 50
Mango Pineapple Smoothie (Small) 5 40
Strawberry Banana Smoothie (Medium) 5 60
Strawberry Banana Smoothie (Small) 5 50
Blueberry Pomegranate Smoothie (Small) 5 40
In [11]: